SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563071 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563071 [ RunTime:0.004064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000076,249313,481424,332618,68904,949984,1017554,415414,800762,536439,798214,596712,384648,583209,911434,748203,201848,361900,346506,678830,400306,320624,1039875,854811,40393,749357,616144,589609,874392,795141,140519,963579,583947,457619,694818,894250,182208,70938,919538,507736,509456,672972,102537,543663,977645,56457,707826,210947,177005,607219,262265,985427,360792,126717,551966,305632,484708,149237,422028,846600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001535s ]