SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143948 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143948 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594066,502473,426329,1031306,726174,721298,141251,885977,182847,646073,1024619,497380,277699,878441,245787,710890,894049,9896,305809,593166,135809,1001465,99171,780385,289791,923585,505832,408539,162497,628747,695080,316845,1036228,198506,189219,298527,574548,498927,614862,370086,126149,216893,12950,439438,214878,513678,424664,533503,491831,687676,1013242,680299,717994,595830,732759,508056,583516,838846,1005956,715882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]